Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	2774
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	271.0 KiB
Average record size in memory	100.0 B

Variable types

Numeric	11
DateTime	2

Alerts

`df_index` is highly correlated with `days_`	High correlation
`gross_revenue` is highly correlated with `quantity` and 3 other fields	High correlation
`quantity` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`purchases` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`days_` is highly correlated with `df_index` and 3 other fields	High correlation
`buy_` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`df_index` is highly correlated with `days_`	High correlation
`gross_revenue` is highly correlated with `quantity` and 2 other fields	High correlation
`quantity` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`purchases` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`days_` is highly correlated with `df_index`	High correlation
`buy_` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`df_index` is highly correlated with `days_`	High correlation
`gross_revenue` is highly correlated with `quantity` and 2 other fields	High correlation
`quantity` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`purchases` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`days_` is highly correlated with `df_index`	High correlation
`buy_` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`df_index` is highly correlated with `avg_recency_days` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `quantity` and 3 other fields	High correlation
`recency_in_days` is highly correlated with `days_`	High correlation
`quantity` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`purchases` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`avg_ticket` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`avg_recency_days` is highly correlated with `df_index` and 1 other fields	High correlation
`days_` is highly correlated with `df_index` and 2 other fields	High correlation
`buy_` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 51.90076813)	Skewed
`frequency` is highly skewed (γ1 = 46.08548575)	Skewed
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`recency_in_days` has 34 (1.2%) zeros	Zeros

Reproduction

Analysis started	2022-05-26 11:11:55.542561
Analysis finished	2022-05-26 11:12:45.663403
Duration	50.12 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	2774
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2215.728911

Minimum	0
Maximum	5612
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	179.65
Q1	879.25
median	2017.5
Q3	3359.75
95-th percentile	4878.15
Maximum	5612
Range	5612
Interquartile range (IQR)	2480.5

Descriptive statistics

Standard deviation	1501.511553
Coefficient of variation (CV)	0.6776603154
Kurtosis	-0.954277711
Mean	2215.728911
Median Absolute Deviation (MAD)	1220.5
Skewness	0.3797883099
Sum	6146432
Variance	2254536.943
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
2875	1	< 0.1%
2861	1	< 0.1%
2863	1	< 0.1%
2864	1	< 0.1%
2867	1	< 0.1%
2868	1	< 0.1%
2871	1	< 0.1%
2872	1	< 0.1%
2873	1	< 0.1%
Other values (2764)	2764	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5612	1	< 0.1%
5602	1	< 0.1%
5596	1	< 0.1%
5571	1	< 0.1%
5565	1	< 0.1%
5554	1	< 0.1%
5553	1	< 0.1%
5537	1	< 0.1%
5536	1	< 0.1%
5527	1	< 0.1%

customer_id
Real number (ℝ_≥0)

UNIQUE

Distinct	2774
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15285.69971

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.0 KiB

Quantile statistics

Minimum	12347
5-th percentile	12626.65
Q1	13815.25
median	15242.5
Q3	16779.75
95-th percentile	17950.35
Maximum	18287
Range	5940
Interquartile range (IQR)	2964.5

Descriptive statistics

Standard deviation	1714.984904
Coefficient of variation (CV)	0.1121953811
Kurtosis	-1.206915065
Mean	15285.69971
Median Absolute Deviation (MAD)	1483.5
Skewness	0.01599078757
Sum	42402531
Variance	2941173.222
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
15172	1	< 0.1%
13516	1	< 0.1%
14323	1	< 0.1%
18079	1	< 0.1%
14700	1	< 0.1%
15027	1	< 0.1%
17029	1	< 0.1%
13220	1	< 0.1%
15985	1	< 0.1%
Other values (2764)	2764	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18265	1	< 0.1%
18263	1	< 0.1%
18261	1	< 0.1%
18260	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2760
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2904.649153

Minimum	36.56
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	36.56
5-th percentile	264.557
Q1	628.195
median	1170.87
Q3	2423.86
95-th percentile	7579.4915
Maximum	279138.02
Range	279101.46
Interquartile range (IQR)	1795.665

Descriptive statistics

Standard deviation	10927.08309
Coefficient of variation (CV)	3.761928726
Kurtosis	331.9637848
Mean	2904.649153
Median Absolute Deviation (MAD)	690.475
Skewness	16.26124122
Sum	8057496.75
Variance	119401144.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
731.9	2	0.1%
1078.96	2	0.1%
734.94	2	0.1%
1353.74	2	0.1%
178.96	2	0.1%
598.2	2	0.1%
2053.02	2	0.1%
1314.45	2	0.1%
745.06	2	0.1%
379.65	2	0.1%
Other values (2750)	2754	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
36.56	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%
70.02	1	< 0.1%
77.4	1	< 0.1%
84.65	1	< 0.1%
90.3	1	< 0.1%
93.35	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
140438.72	1	< 0.1%
124564.53	1	< 0.1%
117375.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%

recency_in_days
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	252
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.62797404

Minimum	0
Maximum	372
Zeros	34
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	10
median	29
Q3	73
95-th percentile	211
Maximum	372
Range	372
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	68.41902268
Coefficient of variation (CV)	1.208219503
Kurtosis	3.432119089
Mean	56.62797404
Median Absolute Deviation (MAD)	23.5
Skewness	1.898364316
Sum	157086
Variance	4681.162665
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.6%
4	87	3.1%
3	85	3.1%
2	85	3.1%
8	76	2.7%
10	67	2.4%
9	66	2.4%
7	65	2.3%
17	62	2.2%
22	55	2.0%
Other values (242)	2027	73.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	34	1.2%
1	99	3.6%
2	85	3.1%
3	85	3.1%
4	87	3.1%
5	43	1.6%
7	65	2.3%
8	76	2.7%
9	66	2.4%
10	67	2.4%

Value	Count	Frequency (%)
372	1	< 0.1%
366	1	< 0.1%
360	1	< 0.1%
358	3	0.1%
354	1	< 0.1%
337	1	< 0.1%
336	2	0.1%
334	1	< 0.1%
333	2	0.1%
330	1	< 0.1%

quantity
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1632
Distinct (%)	58.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1697.820476

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	119
Q1	330.25
median	699.5
Q3	1478
95-th percentile	4645.5
Maximum	196844
Range	196842
Interquartile range (IQR)	1147.75

Descriptive statistics

Standard deviation	6074.430131
Coefficient of variation (CV)	3.577781171
Kurtosis	438.7272215
Mean	1697.820476
Median Absolute Deviation (MAD)	449
Skewness	17.33919681
Sum	4709754
Variance	36898701.42
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
150	8	0.3%
246	8	0.3%
219	7	0.3%
394	7	0.3%
200	7	0.3%
260	7	0.3%
516	7	0.3%
1200	7	0.3%
300	7	0.3%
Other values (1622)	2698	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
25	1	< 0.1%
27	2	0.1%
30	1	< 0.1%
32	1	< 0.1%
33	2	0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
79963	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
62812	1	< 0.1%
58243	1	< 0.1%
57785	1	< 0.1%

purchases
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	55
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.052992069

Minimum	2
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	204
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	9.071603018
Coefficient of variation (CV)	1.498697324
Kurtosis	183.9451599
Mean	6.052992069
Median Absolute Deviation (MAD)	2
Skewness	10.62466362
Sum	16791
Variance	82.29398131
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	781	28.2%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%
Other values (45)	278	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	781	28.2%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	2772
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.33922977

Minimum	2.150588235
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2.150588235
5-th percentile	4.852702153
Q1	12.42654846
median	17.94687607
Q3	25.07465812
95-th percentile	88.42744262
Maximum	56157.5
Range	56155.34941
Interquartile range (IQR)	12.64810966

Descriptive statistics

Standard deviation	1071.049129
Coefficient of variation (CV)	20.46360127
Kurtosis	2718.321494
Mean	52.33922977
Median Absolute Deviation (MAD)	6.333840598
Skewness	51.90076813
Sum	145189.0234
Variance	1147146.236
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.47833333	2	0.1%
4.162	2	0.1%
18.15222222	1	< 0.1%
34.63101695	1	< 0.1%
7.603333333	1	< 0.1%
23.90492647	1	< 0.1%
31.5775	1	< 0.1%
16.80722222	1	< 0.1%
28.75566929	1	< 0.1%
19.4373913	1	< 0.1%
Other values (2762)	2762	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%
615.75	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1155
Distinct (%)	41.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78.8018889

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	1
5-th percentile	13
Q1	34.24166667
median	59
Q3	99
95-th percentile	224
Maximum	366
Range	365
Interquartile range (IQR)	64.75833333

Descriptive statistics

Standard deviation	66.51501118
Coefficient of variation (CV)	0.8440788934
Kurtosis	3.674436164
Mean	78.8018889
Median Absolute Deviation (MAD)	30
Skewness	1.828361094
Sum	218596.4398
Variance	4424.246712
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
70	21	0.8%
46	18	0.6%
55	17	0.6%
91	16	0.6%
49	16	0.6%
31	16	0.6%
35	15	0.5%
42	15	0.5%
21	15	0.5%
26	14	0.5%
Other values (1145)	2611	94.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9	0.3%
2	4	0.1%
2.861538462	1	< 0.1%
3	6	0.2%
3.330357143	1	< 0.1%
3.351351351	1	< 0.1%
4	5	0.2%
4.191011236	1	< 0.1%
4.275862069	1	< 0.1%
4.5	1	< 0.1%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

max_
Date

Distinct	252
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Memory size	21.8 KiB

Minimum	2016-11-30 00:00:00
Maximum	2017-12-07 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

min_
Date

Distinct	297
Distinct (%)	10.7%
Missing	0
Missing (%)	0.0%
Memory size	21.8 KiB

Minimum	2016-11-29 00:00:00
Maximum	2017-11-28 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

days_
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	373
Distinct (%)	13.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	205.0392934

Minimum	2
Maximum	374
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	24.65
Q1	108
median	212
Q3	303
95-th percentile	363
Maximum	374
Range	372
Interquartile range (IQR)	195

Descriptive statistics

Standard deviation	111.1851779
Coefficient of variation (CV)	0.5422627831
Kurtosis	-1.217319388
Mean	205.0392934
Median Absolute Deviation (MAD)	97
Skewness	-0.162858992
Sum	568779
Variance	12362.14379
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
365	28	1.0%
351	26	0.9%
358	25	0.9%
367	20	0.7%
352	20	0.7%
356	19	0.7%
366	18	0.6%
344	18	0.6%
211	17	0.6%
357	17	0.6%
Other values (363)	2566	92.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	9	0.3%
3	4	0.1%
4	5	0.2%
5	4	0.1%
6	3	0.1%
7	2	0.1%
8	7	0.3%
9	5	0.2%
10	3	0.1%
11	4	0.1%

Value	Count	Frequency (%)
374	5	0.2%
373	8	0.3%
372	8	0.3%
371	8	0.3%
370	6	0.2%
369	10	0.4%
368	11	0.4%
367	20	0.7%
366	18	0.6%
365	28	1.0%

buy_
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	55
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.052992069

Minimum	2
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	204
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	9.071603018
Coefficient of variation (CV)	1.498697324
Kurtosis	183.9451599
Mean	6.052992069
Median Absolute Deviation (MAD)	2
Skewness	10.62466362
Sum	16791
Variance	82.29398131
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	781	28.2%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%
Other values (45)	278	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	781	28.2%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1225
Distinct (%)	44.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.04969219171

Minimum	0.005449591281
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0.005449591281
5-th percentile	0.008746355685
Q1	0.01575839204
median	0.0243902439
Q3	0.04166666667
95-th percentile	0.1153846154
Maximum	17
Range	16.99455041
Interquartile range (IQR)	0.02590827462

Descriptive statistics

Standard deviation	0.3375950011
Coefficient of variation (CV)	6.793723309
Kurtosis	2296.521881
Mean	0.04969219171
Median Absolute Deviation (MAD)	0.01069454458
Skewness	46.08548575
Sum	137.8461398
Variance	0.1139703848
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0625	17	0.6%
0.02777777778	17	0.6%
0.02380952381	16	0.6%
0.09090909091	15	0.5%
0.08333333333	15	0.5%
0.03448275862	14	0.5%
0.02941176471	14	0.5%
0.02127659574	13	0.5%
0.01923076923	13	0.5%
0.03571428571	13	0.5%
Other values (1215)	2627	94.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	1	< 0.1%
1.142857143	1	< 0.1%
1	8	0.3%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%
0.5	3	0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_in_days	quantity	purchases	avg_ticket	avg_recency_days	max_	min_	days_	buy_	frequency
0	0	17850	5391.21	372	1733	34	18.152222	1.000000	2016-11-30	2016-11-29	2	34	17.000000
1	1	13047	3232.59	56	1390	9	18.904035	52.833333	2017-10-12	2016-11-29	318	9	0.028302
2	2	12583	6705.38	2	5028	15	28.902500	26.500000	2017-12-05	2016-11-29	372	15	0.040323
3	3	13748	948.25	95	439	5	33.866071	92.666667	2017-09-03	2016-11-29	279	5	0.017921
4	4	15100	876.00	333	80	3	292.000000	20.000000	2017-01-08	2016-11-29	41	3	0.073171
5	5	15291	4623.30	25	2102	14	45.326471	26.769231	2017-11-12	2016-11-29	349	14	0.040115
6	6	14688	5630.87	7	3621	21	17.219786	19.263158	2017-11-30	2016-11-29	367	21	0.057221
7	7	17809	5411.91	16	2057	12	88.719836	39.666667	2017-11-21	2016-11-29	358	12	0.033520
8	8	15311	60767.90	0	38194	91	25.543464	4.191011	2017-12-07	2016-11-29	374	91	0.243316
9	9	16098	2005.63	87	613	7	29.934776	47.666667	2017-09-11	2016-11-29	287	7	0.024390

Last rows

	df_index	customer_id	gross_revenue	recency_in_days	quantity	purchases	avg_ticket	avg_recency_days	max_	min_	days_	buy_	frequency
2764	5527	17290	525.24	3	404	2	5.149412	13.0	2017-12-04	2017-11-21	14	2	0.142857
2765	5536	14785	77.40	10	84	2	25.800000	5.0	2017-11-27	2017-11-22	6	2	0.333333
2766	5537	17254	272.44	4	252	2	2.432500	11.0	2017-12-03	2017-11-22	12	2	0.166667
2767	5553	17232	421.52	2	203	2	11.708889	12.0	2017-12-05	2017-11-23	13	2	0.153846
2768	5554	17468	137.00	10	116	2	27.400000	4.0	2017-11-27	2017-11-23	5	2	0.400000
2769	5565	13596	697.04	5	406	2	4.199036	7.0	2017-12-02	2017-11-25	8	2	0.250000
2770	5571	14893	1237.85	9	799	2	16.956849	2.0	2017-11-28	2017-11-26	3	2	0.666667
2771	5596	14126	706.13	7	508	3	47.075333	3.0	2017-11-30	2017-11-27	4	3	0.750000
2772	5602	13521	1092.39	1	733	3	2.511241	4.5	2017-12-06	2017-11-27	10	3	0.300000
2773	5612	15060	301.84	8	262	4	2.515333	1.0	2017-11-29	2017-11-28	2	4	2.000000

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows